<?
include "../conn.php";
    $sid=$_GET['sid'];

    $sql="select * from grade WHERE  StduentId=$sid";
    $result=$conn->query($sql);
    $row=$result->fetch_array();
    $mark=$row[6]+$row[8]+$row[10];
     if($mark>=90) {$grade="优";}
    else if($mark>=80){$grade="良";}
    else if($mark>=70){$grade="中等";}
    else if($mark>=60){$grade="及格";}
    else $grade="不及格";
?>
<!DOCTYPE html>
<html>
<head lang="zh">
    <meta charset="UTF-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
<!--    <link rel="stylesheet" type="text/css" href="../css/demo.css">-->
    <title></title>
</head>

<body>
<div class="container" align="center">
    <div class="row">
<div  id="pagecontent" >

<h3 style="text-align: center">广州大学华软软件学院</h3>
<h3 style="text-align: center">本科毕业论文（设计）成绩单</h3>
<table border="1" cellpadding="3" cellspacing="0"   >
    <tr >
        <td width="90" valign="center" colspan="2" style="text-align: center">姓名</td>
        <td width="100" valign="center" colspan="4" style="text-align: center"><?=$row[1]?></td>
        <td width="90" valign="center" colspan="2" style="text-align: center">学号</td>
        <td width="160" valign="center" colspan="4" style="text-align: center"><?=$row[2]?></td>
        <td width="150" valign="center" colspan="3" style="text-align: center">专业方向</td>
        <td width="160" valign="center" colspan="4" style="text-align: center"><?=$row[3]?></td>
    </tr>
    <tr>
        <td width="90" height="30" valign="center" colspan="2" style="text-align: center">题目</td>
        <td width="560" height="30" valign="center" colspan="17" ><?=$row[4]?></td>
    </tr>
    <tr>
        <td width="90" height="220"  colspan="2" rowspan="" style="text-align: center">指导教师评语（占论文总成绩的60%）</td>
        <td width="560" height="220"  colspan="17" rowspan=""  valign="top">
            <table width="650">
                <tr valign="top" height="160">
                    <td ><?=$row[5]?></td>
                </tr>
                <tr valign="top" height="40">
                    <td>成绩：<?=$row[6]?>&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp签名:</td>
                </tr>
                <tr align="right">
                    <td>年&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp月&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp日</td>
                </tr>
            </table>
        </td>
    </tr>
    <tr>
        <td width="90" height="220" valign="center" colspan="2" rowspan="" style="text-align: center">评阅教师评语（占论文总成绩的20%）
        </td>
        <td width="560" height="220" valign="center" colspan="17" rowspan="" >
            <table width="650">
                <tr valign="top" height="160">
                    <td ><?=$row[7]?></td>
                </tr>
                <tr valign="top" height="40">
                    <td>成绩：<?=$row[8]?>&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp签名:</td>
                </tr>
                <tr align="right">
                    <td>年&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp月&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp日</td>
                </tr>
            </table>
        </td>
    </tr>
    <tr>
        <td width="90" height="220" valign="center" colspan="2" rowspan="" style="text-align: center">答辩组评语（占论文总成绩的20%）
        </td>
        <td width="560" height="220" valign="center" colspan="17" rowspan="">
            <table width="650">
                <tr valign="top" height="160">
                    <td ><?=$row[9]?></td>
                </tr>
                <tr valign="top" height="40">
                    <td>成绩：<?=$row[10]?>&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp答辩组签名:</td>
                </tr>
                <tr align="right">
                    <td>年&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp月&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp日</td>
                </tr>
            </table>
        </td>
    </tr>
    <tr>
        <td width="90" height="100" valign="center" colspan="2" rowspan="" style="text-align: center">总成绩</td>
        <td width="560" height="100"  valign="center" colspan="17" rowspan="">
            <table width="650">
                <tr valign="top" height="50">
                    <td style="font-size: 30px"><?=$grade?></td>
                </tr>
                <tr valign="top" height="50" align="right">
                    <td>系主任签名:&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp系(章)&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp</td>
                </tr>
                <tr align="right">
                    <td>年&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp月&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp日</td>
                </tr>
            </table>
        </td>
    </tr>

</table>
</center>
</div>
        </div>
    </div>


<div align="center">
    <a class="btn btn-default jquery-word-export" href="javascript:void(0)">
        <span class="word-icon">W</span>
        导出为.doc文档
    </a>
</div>


    <script type="text/javascript" src="../js/jquery-2.1.1.min.js"></script>
    <script type="text/javascript" src="../js/FileSaver.js"></script>
    <script type="text/javascript" src="../js/jquery.wordexport.js"></script>

    <script type="text/javascript">
        jQuery(document).ready(function($) {
            $("a.jquery-word-export").click(function(event) {

                $("#pagecontent").wordExport("<?=$row[2]?>     <?=$row[1]?>      成绩单");
            });
        });
    </script>

</body>
</html>

<?


?>